Work Item

Attributes

Expand this link to view the attributes available as part of the Work Item iCube:

Attributes	Description
Assigned To	User responsible for working on the Work Item Note: This attribute is not supported for the Digital.ai Agility source system.
Backlog Group	Provides logical groups to roll sub-features up into larger groups for tracking purposes. Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 1	Backlog group, which is one level above the lowest in the hierarchy to which the work item belongs to. Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 2	Backlog group, which is two levels above the lowest level in the hierarchy is shown in this level. Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 3	Backlog group, which is three levels above the lowest level in the hierarchy is shown in this level. Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 4	Backlog group, which is four levels above the lowest level in the hierarchy is shown in this level Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 5	Backlog group, which is five levels above the lowest level in the hierarchy is shown in this level Note: This attribute is only supported for Digital.ai Agility source system.
Backlog Group Level 6	Backlog group, which is six levels above the lowest level in the hierarchy is shown in this level. Note: This attribute is only supported for Digital.ai Agility source system.
Business Value	Business Value of Work Item
Calendar Date	Gregorian calendar date displayed in the format 'M/D/YYYY'
Calendar Month	Gregorian calendar month displayed in the format 'Mon YYYY'
Calendar Quarter	Gregorian calendar quarter displayed in the format 'Q# YYYY'
Calendar Week	Gregorian calendar week displaying the week number. For example, W21, W22
Calendar Year	Gregorian calendar year displayed in the format YYYY
Cancelled By	Person who cancelled the work item. Note: This attribute is not supported for the Digital.ai Agility source system.
Cancelled DateTime	Date and time when the work item was cancelled Note: This attribute is not supported for the Digital.ai Agility source system.
Class of Service	Source value of Class of Service
Code Complexity	Created for Complexity Rank of Code
Completed By	Person who completed the work item. Note: This attribute is not supported for the Digital.ai Agility source system.
Completed DateTime	Date and time when the Work Item was last closed, or was set to 'Closed' status Note: This attribute is not supported for the Digital.ai Agility source system.
Complexity	Created for Work Item Complexity
Component	Component to which the work item is associated. This attribute will have a valid value only when there is a single component associated to the work item. If more than one component is specified for the work item, the value will default to 'Multiple'. If no component is specified, the value will default to 'Unspecified' Note: This attribute is not supported for the Digital.ai Agility source system.
Created By	Person who created the work item
Created DateTime	Date and time when the Work Item was created Note: This attribute is not supported for the Digital.ai Agility source system.
Current Estimate	Remaining estimate updated in the work item when the work item is 'In Progress'
Date	Date on which the status of the Work Item moved to 'Created', 'In Progress', 'Resolved', or 'Completed'
Day of Month	Day of month between 1 and 31
Day of Week	Day of week
Day of Year	Day of the year between 1 to 366
Delivery Category	Category of Delivery for Work Item
Description	Short description about the work item.
Due Date	Date by when the Work Item is scheduled for completion.
Earliest Fix Version	Version to which the selected work item is associated as 'Fix Version' Note: This attribute is not supported for the Digital.ai Agility source system.
Employee	Name of the employee Note: This attribute is not supported for the Digital.ai Agility source system.
Environment	Details of the environment on which the user is working for the work item
Epic	Epic number to which the work item is linked
Epic Name	Name of the epic to which the work item is linked
Fix Version Release DateTime	Date and time of release of version in which the work item was addressed Note: This attribute is not supported for the Digital.ai Agility source system.
In Progress DateTime	Date and time when the Work Item first moved to the 'In Progress' status category Note: This attribute is not supported for the Digital.ai Agility source system.
In Progress Flag	Indicates whether the Work Item is currently in the 'In Progress' status category Note: This attribute is not supported for the Digital.ai Agility source system.
Iteration Count	Iteration or Sprint to which the Work Item is associated. If a work item is associated with more than one iteration, only the latest iteration will be considered
Lagging Count of Days	Count of number of days since the first data record till current day
Lagging Count of Months	Count of number of months since the first data record till current month
Lagging Count of Quarters	Count of number of quarters since the first data record till current quarter
Lagging Count of Weeks	Count of number of weeks since the first data record till current week
Lagging Count of Years	Count of number of years since the first data record till current year
Last Iteration	The last sprint (iteration) to which the work item is associated with.
Last Iteration Actual End DateTime	Date and time when the last iteration was closed
Last Iteration Planned End DateTime	Date and time when the last iteration was expected to end
Last Iteration Start DateTime	Date and time when the last iteration began
Multiple Assignment Flag	Indicates whether the Work Item has ever been assigned to more than one user Note: This attribute is not supported for the Digital.ai Agility source system.
Original Estimate	Original estimate mentioned in the Work Item
Overdue Flag	Indicates whether the Work Item is overdue (Current date is past the due date and the status category is less than 'Resolved') Note: This attribute is not supported for the Digital.ai Agility source system.
Planned End On	Date on which the work item is planned for completion Note: This attribute is supported only for Digital.ai Agility source system
Planned Start On	Date on which the work item is planned to begin Note: This attribute is supported only for Digital.ai Agility source system
Priority	Priority of the Work Item
Priority De-escalated Flag	Indicates whether the current priority of the Work Item is lower than the original priority
Priority Escalated Flag	Indicates whether the current priority of the Work Item is higher than the original priority
Program Increment	Name of the Program Increment
Project	Project to which the Work Item is associated
Project Category	Current category of the project. Note: This attribute is not supported for the Digital.ai Agility source system.
Project Classification	The type of project the current project has been classified under Note: This attribute is not supported for the Digital.ai Agility source system.
Proposed Flag	Indicates whether the Work Item is currently in the 'Proposed' status category Note: This attribute is not supported for the Digital.ai Agility source system.
Reason	Reason for closing the work item
Reopened Flag	Indicates whether the Work Item has ever been reopened Note:This attribute is not supported for the Digital.ai Agility source system.
Reported By	User who reported the Work Item or is affected by the work item Note:This attribute is not supported for the Digital.ai Agility source system.
Resolution Reason	Reason given for resolution Note: This attribute is only supported for Digital.ai Agility source system.
Resolution Type	A description of the resolution carried out for the Work Item. This field will only have a value once the work item reaches the Resolved or Completed status category
Resolved By	Person who resolved the work item
Resolved DateTime	Date and time when the Work Item was last Resolved
Risk	Risk associated with the work item
Risk Reduction	Risk Reduction for Work Item
Risk Scale	Created for Work Item Risk Scale
Severity	Severity of the work item Note: This attribute is not supported for the Digital.ai Agility source system.
Status (Source)	Status of the work item as mentioned in the source
Status (Standardized)	Internal standardized values denoting the status of Work Items.
Status Category (Source)	Current status category of the Work Item. Status category is a standardized set of statuses across work flows such as Proposed, In Progress, Resolved, and Completed
Story Points	Story points assigned to the work item. Story point is a standard method used by agile teams to measure the difficulty involved in implementing a story by giving it points.
Summary	Title or brief summary about the Work Item
Swag	Swag provides a way to compare the size, time, and effort that it will take to complete a set of features without going through detailed backlog estimation activities
Team	Logical Grouping of all the work item owners across multiple work items. Note: This attribute is only supported for Digital.ai Agility source system.
Time Criticality	Created for Time Criticality of Work Item
Time Spent	Amount of time spent on the Work Item
Updated By	Person who last made changes to the work item
Updated DateTime	Date and time when the work item was changed
Work Item	Work Item refers to an issue that represents work to be completed. Work items can be of various types, such as task, enhancement, bug, epic, and so on
Work Item Category Type	Category Type from where the requirements originated. Note: This attribute is only supported for Digital.ai Agility source system.
Work Item Level 1	Work Item which is one level above the lowest level in the hierarchy is shown in this level Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Level 2	Work Item which is two levels above the lowest level in the hierarchy is shown in this level Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Level 3	Work Item which is three levels above the lowest level in the hierarchy is shown in this level Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Level 4	Work Item which is four levels above the lowest level in the hierarchy is shown in this level Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Level 5	Work Item which is five levels above the lowest level in the hierarchy is shown in this level Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Level 6	Work Item which is highest in the hierarchy is shown in this level Note:This attribute is not supported for the Digital.ai Agility source system.
Work Item Link Type	Indicates the link the work item has with the parent work item (For example, is implemented by, is resolved by, implements, and so on) Note: This attribute is not supported for the Digital.ai Agility source system.
Work Item Number	Unique identifier for the Work Item
Work Item Planned End Date	Planned end date by when the Epic is expected to be completed. Note: This attribute is only supported for Digital.ai Agility source system.
Work Item Planned Start Date	Planned Start date by when the Epic is expected to Start. Note: This attribute is only supported for Digital.ai Agility source system.
Work Item Resolution Reason	The detailed resolution for work item for type defect. Note: This attribute is only supported for Digital.ai Agility source system.
Work Item Type	Type of work item. For example, Epic, Story, Improvement, Bug, and so on

Metrics

Expand this link to view a list of all the metrics available as part of the Work Item iCube:

Metric Name	Description	Formula	Expected Value
% Work Item Business Value Achievement	Percentage of business value completed compared to planned	WI actual business value/WI planned business value	Higher is better
% Work Items without Current estimate	Percentage of work items which don’t have any Current Estimate defined	((([InProgress Without Current Estimate] + [Completed Without Current Estimate]) + [Resolved Without Current Estimate]) / (([In Progress Work Items] + [Completed Work Items]) + [Resolved Work Items]))	>=0, 0 is ideal
% Work Items without Original estimate	Percentage of work items which don’t have any Original Estimate defined	((([InProgress Without Original Estimate] + [Completed Without Original Estimate]) + [Resolved Without Original Estimate]) / (([In Progress Work Items] + [Completed Work Items]) + [Resolved Work Items]))	>=0, 0 is ideal
% Work Items without Story Point	Percentage of work items which don’t have any Story Points defined	Count of work item without story points(In Progress + Resolved + Completed work items)/ (In Progress + Resolved + Completed work items)	>=0, 0 is ideal
% Work Items without Time Spent	Percentage of work items which don’t have any Time Spent defined	Count of work item without time Spent / (In Progress + Resolved + Completed work items)	>=0
Actual Business Value	Actual Business Value of Work Item	Sum([Work Item Actual Business Value])	>0
Avg Cycle Time (Days)	Average number of days since the work item first moved to the IN PROGRESS until it is COMPLETED. If the work item is completed, the value is the difference between In Progress Date and the Completed Date else the value is the difference between In Progress Date and the current time	Age Since In Progress (in days)/ [Created work items - Proposed work items]	0 or >0
Avg Days Since Last Update	Average number of days since the work item was last updated. This metric is only applicable to work items that are not COMPLETED.	(Days Since Last Update)/(Current Open Work Items)	>0
Avg Duration Created to Cancelled (Days)	Average number of days from the time the work item was created to it being canceled.	[Duration Created to Cancelled (days)] / [Cancelled Work Items]	>=0
Avg Duration Created to Completed (Days)	Average number of days from the time the work item was created to it being completed. The value of this metric is blank if the work item is not yet completed	[Duration Created to Completed (days)] / [Completed Work Items]	>0, Closer to 0 is ideal
Avg Duration Created to Resolved (Days)	Average number of days from the time the work item was created to it being resolved. The value of this metric is blank if the work item is not yet resolved	[Duration Created to Resolved (days)] / [Resolved Work Items]	>0, Closer to 0 is ideal
Avg Duration In Progress to Cancelled (Days)	Average number of days from the first time the work item moved to the In Progress state to it being canceled. Note: This metric is not supported for the Digital.ai Agility source system.	[Duration InProgress to Cancelled (days)] / [Cancelled Work Items]	>=0, Closer to 0 is ideal
Avg Duration In Progress to Completed (Days)	Average number of days from the first time the work item moved to the In Progress state to it being completed. The value of this metric is blank if the work item is not yet completed	[Duration InProgress to Completed (days)] / [Completed Work Items]	>0, Closer to 0 is ideal
Avg Duration In Progress to Resolved (Days)	Average number of days from the first time the work item moved to the In Progress state to it being resolved. The value of this metric is blank if the work item is not yet resolved	[Duration InProgress to Resolved (days)] / [Resolved Work Items]	>0, Closer to 0 is ideal
Avg Lead Time (Days)	Average number of days from the time the work item was created until it is completed. If the work item is completed, the value is the difference between Created Date and Completed Date else the value is the difference between Created Date and the current time	Sum [Age Since Creation] / [Created Work Items]	0 or >0
Avg No. of Bugs per User Story	Total number of Bugs or Number of User Stories	[No. of Bugs] / [No. of User Stories]	>=0
Avg No. of Stories Linked per Epic	Total number Linked Stories/ Total Epics Note: This metric is not supported for the Digital.ai Agility source system.	[No. of Linked Stories] / [No. of Epics]	>=0
Avg No. of Story Points per Epic	Total of story points of linked stories/ Number of Epics	[Total Story Points of Linked Stories] / [No. of Epics]	>=0
Avg No. of Sub-Tasks per Task	Total Number of Sub-tasks or Total Number of tasks Note: This metric is not supported for the Digital.ai Agility source system.	[No. of Sub-Tasks] / [Created Work Items]	>=0
Avg No. of Tasks per User Story	Total Number of Linked Tasks or Total User Stories	[No. of Linked Tasks] / [No. of User Stories]	>=0
Avg Weight of Task	Total of story points or Total number of tasks Note: This metric is not supported for the Digital.ai Agility source system.	[Story Points] / [Created Work Items]	>=0
Cancelled Work Items	Count of all work items whose current status category is "Cancelled" Note: This metric is not supported for the Digital.ai Agility source system.	Count [Cancelled Work Items]	0 is ideal
Completed Story Points	Sum of story points completed
Completed Work Items	Count of all work items whose current status category is "Completed" Note: This metric is not supported for the Digital.ai Agility source system.	Count [Work Items Completed]	>=0
Created Without Original Estimate	Work Items created without estimate		0 is ideal
Created Work Items	Count of all work items that are created.	Count [Work Items Created]	>=0
Current Estimate - Completed (Hours)	Current estimated time required to complete the work item. The unit of measure is based on how estimates are configured in the source system (hours, story points). Work items are evaluated based on their completed dates Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Current Estimate Completed]	>0, Closer to 0 is ideal
Current Estimate - Created (Hours)	Current estimated time required to complete the work item. The unit of measure is based on how estimates are configured in the source system (hours, story points). Work items are evaluated based on their created dates	Sum [Current Estimate Opened]	>0
Days Until Due Date	Total number of days until the work item is due to be completed. Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Days Until Due Date]	Closer to 0 is ideal
In Progress Work Items	Count of all work items whose current status category is "In Progress"	Count [Work Items In Progress]	>=0
Iteration Count	Number of iterations (sprints) a work item has been through.	Sum [Iteration Count]	>=0
No. of Backlog Groups	Count of all backlog groups		>=0
No. of Bugs Without User Story	Count of Bugs not linked to User story	Count ([Created Work Items]) where Orphan Bug Flag = Y	>=0, 0 is ideal
No. of Defects Created	Count of all defects logged in the system		>=0, 0 is ideal
No. of Invalid Bugs	Count of Bugs marked as Invalid Note: This metric is not supported for the Digital.ai Agility source system.	Count ([Cancelled Work Items]) where Work Item Type = Bug	>=0, 0 is ideal
No. of Program Increments	Count of program increments Note: This metric is supported for the Digital.ai Agility source system only		>0
No. of Resolved Bugs With Re-prioritization	Count of Resolved Bugs with Prioritization different from the original Prioritization	Count ([Resolved Work Items]) where (Work Item Type = Bug and Reprioritization Flag = Y)	>=0, 0 is ideal
No. of Teams	Count of teams		>0
No. of User Stories	Count of user stories		>0
No. of Work Items Missing Fixed Version	Count of all the work items marked as completed where the fixed version is missing Note: This metric is not supported for the Digital.ai Agility source system.	Count ([Completed Work Items]) where Work Item Fix Version = 'UNKNOWN' or 'UNSPECIFIED'	>=0, 0 is ideal
Open Work Items	Number of work items in the backlog (number of work items in 'Open' state)	Count [Created Work Items] where status is Proposed or In Progress	>=0
Original Estimate - Completed (Hours)	Original estimated time required to complete the work item. The unit of measure is based on how estimates are configured in the source system (hours, story points). Work items are evaluated based on their completed dates Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Original Estimate Completed]	>0
Original Estimate - Created (Hours)	Original estimated time required to complete the work item. The unit of measure is based on how estimates are configured in the source system (hours, story points). Work items are evaluated based on their created dates	Sum [Original Estimate Opened]	>0, Closer to 0 is ideal
Orphan User Stories	Number of User story which are not linked to an Epic or another User Story Note: This metric is not supported for the Digital.ai Agility source system.	Count ([Created Work Items]) where Work Item Orphan Story Flag = Y	>=0, 0 is ideal
Orphan Work Items	Number of work items which are not linked to any other work item Note: This metric is not supported for the Digital.ai Agility source system.	Count ([Created Work Items]) where Work Item Orphan Flag = Y	>=0, 0 is ideal
Overdue Work Items	Count of all work items that are past their due date (current date is past the due date and the status category is less than "Resolved") Note: This metric is not supported for the Digital.ai Agility source system.	Count [Work Items Created] WHERE Overdue Flag (ID) = Y	Closer to 0 is ideal
Planned Business Value	Planned Business Value of Work Item	Sum([Work Item Planned Business Value])	>0
Planned Business Value	Business value of the work item planned
Priority De-Escalated Work Items	Count of work items whose current priority is lower than the original priority	Count [Work Items Created] WHERE Priority De-escalated Flag (ID) = Y	Closer to 0 is ideal
Priority Escalated Work Items	Count of work items whose current priority is higher than the original priority	Count [Work Items Created] WHERE Priority Escalated Flag (ID) = Y	Closer to 0 is ideal
Proposed Work Items	Count of all work items whose current status category is "Proposed"	Count (Created Work Items) WHERE Work Item Proposed Flag (ID) = 'Y'	0 or >0
Re-prioritization Count	Count of the number of times 'Priority' is changed for a work item	Sum [Re prioritization count]	Closer to 0 is ideal
Reassignment Count	Total number of times a work item has been reassigned Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Reassignment Count]	Closer to 0 is ideal
Reopened Count	Total number of times a work item has been reopened (Status changes from 'Closed' to an earlier status) Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Work Items Created] WHERE Reopened Flag (ID) = Y	Closer to 0 is ideal
Reopened Work Items	Total number of work items that have been reopened (Status category changes from "Resolved" or "Closed" to an earlier status) Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Reopened Count] Where Reopened Flag (ID) = Y	Closer to 0 is ideal
Resolved Work Items	Count of all work items whose current status category is "Resolved"	Count [Work Items Resolved]	>=0
Story Points	Story points assigned to the work item.	Sum (Story Points)	>0
SWAG	Sum of all the estimates of work item	Sum(SWAG)	>0
Time Spent – Completed (Hours)	Actual amount of time required to resolved or close the work item. This metric is applicable only for resolved or closed work items. Work items are evaluated based on their completed date Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Time Spent Completed]	Closer to 0 is ideal
Time Spent – Created (Hours)	Actual amount of time required to resolved or close the work item. This metric is applicable only for resolved or closed work items. Work items are evaluated based on their created date	Sum [Time Spent Opened]	Closer to 0 is ideal
Votes Count	Total number of votes received by the work item Note: This metric is not supported for the Digital.ai Agility source system.	Sum [Votes]	0 or >0
Work Items Completed Without InProgress	Count of Completed work items which was not moved to InProgress	Count ([Completed Work Items]) where Work Item Not Moved to InProgress Flag = N	Closer to 0 is ideal